Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# YRABSTART

The YRABSTART option sets the specific 100-year period associated with years that are read or displayed using a two-digit abbreviation.

Data type

`INTEGER`

Syntax

YRABSTART = year

Arguments

year

  A four-digit `INTEGER` expression that indicates the year at which the 100-year period begins. You can specify any value in the range 1000 to 9999. However, when you specify a value greater than 9900 for year, requests to read or display two-digit year values that correspond to a year later than 9999 will result in a return value of `NA`. The default is 1950; two-digit year abbreviations are interpreted as being in the range 1950 to 2049 unless a different range is set through YRABSTART.

Examples

Example 24-46 Using the Default Value

The following statements specify a date format and send output to the current outfile.

    DATEFORMAT = '<Mtextl> <d>, <yyyy>'
    SHOW MAKEDATE(96 9 13)

These statements produce the following output.

    September 13, 1996

Example 24-47 Setting the 100-Year Period for a Date

The following statements set a 100-year period of 2000 to 2099 and send the output to the current outfile.

    YRABSTART = 2000
    SHOW MAKEDATE(96 9 13)

These statements produce the following output.

    September 13, 2096